##ENSURE SPREADSHEET IS FILTERED FIRST RUN_DATE (oldest to newest) then by DATETIME (oldest to newest)

Clean data: Look at sample concentrations for each day. Select which value from different run (out of the series of duplicate and dilution runs)

350

Raw Visualize

Create good_id vector for site 350

# Points to background correct
good_id_mc3_bg<-c(68:75, 925:932, 236:238, 2818:2820, 1093:1095, 265:268, 1122:1123, 1979:1982, 280:283, 2884:2887, 1137:1140, 1994:1997, 665:670, 1522:1527, 145:149, 2721:2725, 1002:1006, 694, 695, 697, 795, 1551, 1552, 1554, 1652, 163, 164, 166, 167, 2739:2741, 2743, 1020:1024, 1877:1879, 1881, 2408, 2409, 2411, 2509 )#350

# 85:91, 899:906, 235:237, 1049:1051, 265:268, 1079:1080, 1893, 1894, 1896, 280:283, 1908:1911, 667:670,672, 149:153, 963:967, 706:708, 1520:1522, 2334:2336, 167, 168, 170, 171, 981:984, 1795, 1796

good_id_mc3_fall<-c(291:293, 295, 297, 299, 302, 305, 307, 933:936, 1061:1065, 351, 352, 354, 356, 358, 360, 362, 429, 366, 368, 370, 2821:2832, 1096:1107, 373:379, 381, 382, 390, 391, 1126:1136, 1983:1993, 392, 394, 395, 397, 399, 401:403, 2889, 2891:2895, 2967, 2970, 2971, 2974, 2975, 1141:1146, 1201, 1203, 1204, 1206, 1207, 1998:2003, 2058, 2060, 2061, 2063, 2064, 671:681, 1641:1651, 627:635, 438, 624, 625, 626,629:635, 2726:2738, 1007:1019, 700, 701, 703, 704, 711,714, 717:724, 638:641, 663, 664, 810:814, 2747,2766:2775, 1028, 1047:1056, 1885, 1904:1913, 1653:1666, 2510:2523, 2538) #350

# 301:309, 907:909, 1014:1016, 320, 351:360, 430, 1052:1063, 373, 375:379, 381:384, 1085:1086, 1898:1904, 385:387, 389:393, 1912:1917, 1950:1954, 674, 676:683, 627:632, 634:636, 972:975, 977:980, 716, 718, 719, 721, 723, 724, 638:643, 988:997, 1797, 1799:1811

450

Raw Visualize

Create good_id vector for site 450

## # A tibble: 1 x 1
##       n
##   <int>
## 1     9

350

Visualize Selected Data

450

Visualize Selected Data

Summarize to get mean BG conc per day

## # A tibble: 16 x 6
## # Groups:   date [8]
##    date       site      Cl   DOC     NO3     PO4
##    <date>     <chr>  <dbl> <dbl>   <dbl>   <dbl>
##  1 2018-06-26 350   0.0873 NA    0.0697  NA     
##  2 2018-06-26 450   0.112  NA    0.213   NA     
##  3 2018-06-28 350   0.100   3.67 0.211   NA     
##  4 2018-06-28 450   0.0975  4.12 0.005   NA     
##  5 2018-06-30 350   0.120  NA    0.100    0.0428
##  6 2018-06-30 450   0.0956 NA    0.0334   0.005 
##  7 2018-07-02 350   0.121   3.61 0.005    0.005 
##  8 2018-07-02 450   0.168   4.15 0.0691   0.005 
##  9 2018-07-17 350   0.775  NA    0.00737 NA     
## 10 2018-07-17 450   0.0830 NA    0.0649  NA     
## 11 2018-07-19 350   0.239   2.73 0.0551  NA     
## 12 2018-07-19 450   0.211   2.64 0.0663  NA     
## 13 2018-07-21 350   0.202  NA    0.0488   0.005 
## 14 2018-07-21 450   0.676  NA    0.108    0.005 
## 15 2018-07-23 350   0.320   3.52 0.0505   0.262 
## 16 2018-07-23 450   0.190   3.58 0.214    0.320

Background correct falling limb sample concentrations.

Visually inspect background corrected falling limb sample concentrations for each day.

Graph site 350

Graph Site 450